sdk/samples/all in on code/Visual Studio 2008/CSASPNETRDLCMainSubReport/SubReport.rdlc

   1 <?xml version="1.0" encoding="utf-8"?>
   2 <Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
   3   <DataSources>
   4     <DataSource Name="SQLServer2005DBConnectionString">
   5       <rd:DataSourceID>de3a30f9-b955-407f-9a07-f2167f7a4260</rd:DataSourceID>
   6       <ConnectionProperties>
   7         <DataProvider>
   8         </DataProvider>
   9         <ConnectString>
  10         </ConnectString>
  11       </ConnectionProperties>
  12     </DataSource>
  13   </DataSources>
  14   <InteractiveHeight>11in</InteractiveHeight>
  15   <ReportParameters>
  16     <ReportParameter Name="DepartmentID">
  17       <DataType>Integer</DataType>
  18       <Nullable>true</Nullable>
  19       <AllowBlank>true</AllowBlank>
  20       <Prompt>DepartmentID</Prompt>
  21       <Hidden>true</Hidden>
  22     </ReportParameter>
  23   </ReportParameters>
  24   <rd:DrawGrid>true</rd:DrawGrid>
  25   <InteractiveWidth>8.5in</InteractiveWidth>
  26   <rd:GridSpacing>0.25cm</rd:GridSpacing>
  27   <rd:SnapToGrid>true</rd:SnapToGrid>
  28   <RightMargin>2.5cm</RightMargin>
  29   <LeftMargin>2.5cm</LeftMargin>
  30   <BottomMargin>2.5cm</BottomMargin>
  31   <rd:ReportID>3b0a6c30-f8c9-4fff-97a2-fe43bbe2249b</rd:ReportID>
  32   <PageWidth>21cm</PageWidth>
  33   <DataSets>
  34     <DataSet Name="CourseDataSet_Course">
  35       <Fields>
  36         <Field Name="CourseID">
  37           <DataField>CourseID</DataField>
  38           <rd:TypeName>System.Int32</rd:TypeName>
  39         </Field>
  40         <Field Name="Title">
  41           <DataField>Title</DataField>
  42           <rd:TypeName>System.String</rd:TypeName>
  43         </Field>
  44         <Field Name="Credits">
  45           <DataField>Credits</DataField>
  46           <rd:TypeName>System.Int32</rd:TypeName>
  47         </Field>
  48         <Field Name="DepartmentID">
  49           <DataField>DepartmentID</DataField>
  50           <rd:TypeName>System.Int32</rd:TypeName>
  51         </Field>
  52       </Fields>
  53       <Filters>
  54         <Filter>
  55           <FilterExpression>=Fields!DepartmentID.Value</FilterExpression>
  56           <Operator>Equal</Operator>
  57           <FilterValues>
  58             <FilterValue>=Parameters!DepartmentID.Value</FilterValue>
  59           </FilterValues>
  60         </Filter>
  61       </Filters>
  62       <Query>
  63         <DataSourceName>SQLServer2005DBConnectionString</DataSourceName>
  64         <CommandText>SELECT CourseID, Title, Credits, DepartmentID FROM dbo.Course</CommandText>
  65         <rd:UseGenericDesigner>true</rd:UseGenericDesigner>
  66       </Query>
  67       <rd:DataSetInfo>
  68         <rd:DataSetName>CourseDataSet</rd:DataSetName>
  69         <rd:TableName>Course</rd:TableName>
  70         <rd:TableAdapterName>CourseTableAdapter</rd:TableAdapterName>
  71         <rd:TableAdapterFillMethod>Fill</rd:TableAdapterFillMethod>
  72         <rd:TableAdapterGetDataMethod>GetData</rd:TableAdapterGetDataMethod>
  73       </rd:DataSetInfo>
  74     </DataSet>
  75   </DataSets>
  76   <Width>9.25cm</Width>
  77   <Body>
  78     <ColumnSpacing>1cm</ColumnSpacing>
  79     <ReportItems>
  80       <Table Name="table1">
  81         <DataSetName>CourseDataSet_Course</DataSetName>
  82         <Details>
  83           <TableRows>
  84             <TableRow>
  85               <TableCells>
  86                 <TableCell>
  87                   <ReportItems>
  88                     <Textbox Name="CourseID">
  89                       <rd:DefaultName>CourseID</rd:DefaultName>
  90                       <Style>
  91                         <BorderColor>
  92                           <Default>LightGrey</Default>
  93                         </BorderColor>
  94                         <BorderStyle>
  95                           <Default>Solid</Default>
  96                         </BorderStyle>
  97                         <FontFamily>Tahoma</FontFamily>
  98                         <FontSize>9pt</FontSize>
  99                         <PaddingLeft>2pt</PaddingLeft>
 100                         <PaddingRight>2pt</PaddingRight>
 101                         <PaddingTop>2pt</PaddingTop>
 102                         <PaddingBottom>2pt</PaddingBottom>
 103                       </Style>
 104                       <CanGrow>true</CanGrow>
 105                       <Value>=Fields!CourseID.Value</Value>
 106                     </Textbox>
 107                   </ReportItems>
 108                 </TableCell>
 109                 <TableCell>
 110                   <ReportItems>
 111                     <Textbox Name="Title">
 112                       <rd:DefaultName>Title</rd:DefaultName>
 113                       <Style>
 114                         <BorderColor>
 115                           <Default>LightGrey</Default>
 116                         </BorderColor>
 117                         <BorderStyle>
 118                           <Default>Solid</Default>
 119                         </BorderStyle>
 120                         <FontFamily>Tahoma</FontFamily>
 121                         <FontSize>9pt</FontSize>
 122                         <PaddingLeft>2pt</PaddingLeft>
 123                         <PaddingRight>2pt</PaddingRight>
 124                         <PaddingTop>2pt</PaddingTop>
 125                         <PaddingBottom>2pt</PaddingBottom>
 126                       </Style>
 127                       <CanGrow>true</CanGrow>
 128                       <Value>=Fields!Title.Value</Value>
 129                     </Textbox>
 130                   </ReportItems>
 131                 </TableCell>
 132               </TableCells>
 133               <Height>0.53333cm</Height>
 134             </TableRow>
 135           </TableRows>
 136         </Details>
 137         <Header>
 138           <TableRows>
 139             <TableRow>
 140               <TableCells>
 141                 <TableCell>
 142                   <ReportItems>
 143                     <Textbox Name="textbox2">
 144                       <rd:DefaultName>textbox2</rd:DefaultName>
 145                       <Style>
 146                         <BackgroundColor>DeepSkyBlue</BackgroundColor>
 147                         <BorderColor>
 148                           <Default>LightGrey</Default>
 149                         </BorderColor>
 150                         <BorderStyle>
 151                           <Default>Solid</Default>
 152                         </BorderStyle>
 153                         <FontFamily>Tahoma</FontFamily>
 154                         <FontSize>9pt</FontSize>
 155                         <FontWeight>700</FontWeight>
 156                         <TextAlign>Right</TextAlign>
 157                         <PaddingLeft>2pt</PaddingLeft>
 158                         <PaddingRight>2pt</PaddingRight>
 159                         <PaddingTop>2pt</PaddingTop>
 160                         <PaddingBottom>2pt</PaddingBottom>
 161                       </Style>
 162                       <CanGrow>true</CanGrow>
 163                       <Value>Course ID</Value>
 164                     </Textbox>
 165                   </ReportItems>
 166                 </TableCell>
 167                 <TableCell>
 168                   <ReportItems>
 169                     <Textbox Name="textbox3">
 170                       <rd:DefaultName>textbox3</rd:DefaultName>
 171                       <Style>
 172                         <BackgroundColor>DeepSkyBlue</BackgroundColor>
 173                         <BorderColor>
 174                           <Default>LightGrey</Default>
 175                         </BorderColor>
 176                         <BorderStyle>
 177                           <Default>Solid</Default>
 178                         </BorderStyle>
 179                         <FontFamily>Tahoma</FontFamily>
 180                         <FontSize>9pt</FontSize>
 181                         <FontWeight>700</FontWeight>
 182                         <PaddingLeft>2pt</PaddingLeft>
 183                         <PaddingRight>2pt</PaddingRight>
 184                         <PaddingTop>2pt</PaddingTop>
 185                         <PaddingBottom>2pt</PaddingBottom>
 186                       </Style>
 187                       <CanGrow>true</CanGrow>
 188                       <Value>Title</Value>
 189                     </Textbox>
 190                   </ReportItems>
 191                 </TableCell>
 192               </TableCells>
 193               <Height>0.55873cm</Height>
 194             </TableRow>
 195           </TableRows>
 196           <RepeatOnNewPage>true</RepeatOnNewPage>
 197         </Header>
 198         <TableColumns>
 199           <TableColumn>
 200             <Width>3.75cm</Width>
 201           </TableColumn>
 202           <TableColumn>
 203             <Width>3.5cm</Width>
 204           </TableColumn>
 205         </TableColumns>
 206         <Left>2cm</Left>
 207       </Table>
 208     </ReportItems>
 209     <Height>1.09206cm</Height>
 210   </Body>
 211   <Language>en-US</Language>
 212   <TopMargin>2.5cm</TopMargin>
 213   <PageHeight>29.7cm</PageHeight>
 214 </Report>